Tabela WHContract

Definicja tabeli WHContract

Name

WHContract

Code

WHContract

Comment

Informacje o wykonaniu i finansowaniu kontraktów


Lista kolumn tabeli WHContract

Name

Code

WHContractID

WHContractID

ContractID

ContractID

ContractServID

ContractServID

FullDT

FullDT

ContractNo

ContractNo

ContractorCode

ContractorCode

PositionInContract

PositionInContract

PerformedPoints

PerformedPoints

ApprovedPoints

ApprovedPoints

PaidPoints

PaidPoints

PointPrice

PointPrice

SecondPhasePoints

SecondPhasePoints

PointsPerUnit

PointsPerUnit

UnitsCount

UnitsCount

ContractServiceName

ContractServiceName


Kolumna WHContractID tabeli WHContract

Definicja kolumny WHContractID tabeli WHContract

Name

WHContractID

Code

WHContractID

Data Type

NUMBER(9)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli WHContract

Definicja kolumny ContractID tabeli WHContract

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServID tabeli WHContract

Definicja kolumny ContractServID tabeli WHContract

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullDT tabeli WHContract

Definicja kolumny FullDT tabeli WHContract

Name

FullDT

Code

FullDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna ContractNo tabeli WHContract

Definicja kolumny ContractNo tabeli WHContract

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(45)

Mandatory

No

Comment

Numer kontraktu


Kolumna ContractorCode tabeli WHContract

Definicja kolumny ContractorCode tabeli WHContract

Name

ContractorCode

Code

ContractorCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod produktu kontraktowego


Kolumna PositionInContract tabeli WHContract

Definicja kolumny PositionInContract tabeli WHContract

Name

PositionInContract

Code

PositionInContract

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Pozycja w kontrakcie produktu kontraktowego


Kolumna PerformedPoints tabeli WHContract

Definicja kolumny PerformedPoints tabeli WHContract

Name

PerformedPoints

Code

PerformedPoints

Data Type

FLOAT

Mandatory

No

Comment

Ilosc punktów wykonanych


Kolumna ApprovedPoints tabeli WHContract

Definicja kolumny ApprovedPoints tabeli WHContract

Name

ApprovedPoints

Code

ApprovedPoints

Data Type

FLOAT

Mandatory

No

Comment

Ilosc punktów zatwierdzonych statystycznie


Kolumna PaidPoints tabeli WHContract

Definicja kolumny PaidPoints tabeli WHContract

Name

PaidPoints

Code

PaidPoints

Data Type

FLOAT

Mandatory

No

Comment

Ilosc punktów zaplaconych


Kolumna PointPrice tabeli WHContract

Definicja kolumny PointPrice tabeli WHContract

Name

PointPrice

Code

PointPrice

Data Type

FLOAT

Mandatory

No

Comment

Cena za punkt


Kolumna SecondPhasePoints tabeli WHContract

Definicja kolumny SecondPhasePoints tabeli WHContract

Name

SecondPhasePoints

Code

SecondPhasePoints

Data Type

FLOAT

Mandatory

No

Comment

Ilosc punktów od drugiej fazy rozliczen (dane potrzebne do wyliczania przychodu na lekarza w UCK)


Kolumna PointsPerUnit tabeli WHContract

Definicja kolumny PointsPerUnit tabeli WHContract

Name

PointsPerUnit

Code

PointsPerUnit

Data Type

FLOAT

Mandatory

No

Comment

Ilosc punktów za jednostke


Kolumna UnitsCount tabeli WHContract

Definicja kolumny UnitsCount tabeli WHContract

Name

UnitsCount

Code

UnitsCount

Data Type

FLOAT

Mandatory

No

Comment

Ilosc jednostek


Kolumna ContractServiceName tabeli WHContract

Definicja kolumny ContractServiceName tabeli WHContract

Name

ContractServiceName

Code

ContractServiceName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli WHContract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WHContract

Definicja klucza Identifier_1 tabeli WHContract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment